Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	11010940
Missing cells	14099601
Missing cells (%)	7.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.5 GiB
Average record size in memory	144.0 B

Variable types

Numeric	7
Categorical	11

Alerts

`start_time` has a high cardinality: 9544 distinct values	High cardinality
`blueprint` has a high cardinality: 439 distinct values	High cardinality
`login` has a high cardinality: 1660 distinct values	High cardinality
`position_x` is highly correlated with `map_width` and 1 other fields	High correlation
`position_y` is highly correlated with `map_width` and 1 other fields	High correlation
`map_width` is highly correlated with `position_x` and 2 other fields	High correlation
`map_height` is highly correlated with `position_x` and 2 other fields	High correlation
`position_x` is highly correlated with `map_width` and 1 other fields	High correlation
`position_y` is highly correlated with `map_width` and 1 other fields	High correlation
`map_width` is highly correlated with `position_x` and 2 other fields	High correlation
`map_height` is highly correlated with `position_x` and 2 other fields	High correlation
`map_width` is highly correlated with `map_height`	High correlation
`map_height` is highly correlated with `map_width`	High correlation
`map_name` is highly correlated with `map_height` and 2 other fields	High correlation
`map_height` is highly correlated with `map_name` and 2 other fields	High correlation
`map_width` is highly correlated with `map_name` and 2 other fields	High correlation
`map_thumbnail` is highly correlated with `map_name` and 2 other fields	High correlation
`position_x` is highly correlated with `position_y` and 4 other fields	High correlation
`position_y` is highly correlated with `position_x` and 4 other fields	High correlation
`faf_player_id` is highly correlated with `rating`	High correlation
`rating` is highly correlated with `faf_player_id` and 2 other fields	High correlation
`map_name` is highly correlated with `position_x` and 5 other fields	High correlation
`map_thumbnail` is highly correlated with `position_x` and 5 other fields	High correlation
`map_width` is highly correlated with `position_x` and 4 other fields	High correlation
`map_height` is highly correlated with `position_x` and 4 other fields	High correlation
`blueprint` has 7843923 (71.2%) missing values	Missing
`position_x` has 3127839 (28.4%) missing values	Missing
`position_y` has 3127839 (28.4%) missing values	Missing
`units_number` has 287757 (2.6%) zeros	Zeros
`rating` has 167306 (1.5%) zeros	Zeros

Reproduction

Analysis started	2022-07-28 02:47:56.814525
Analysis finished	2022-07-28 03:00:08.022576
Duration	12 minutes and 11.21 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

id
Real number (ℝ_≥0)

Distinct	9760
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16144023.3

Minimum	16026248
Maximum	16260639
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.0 MiB

Quantile statistics

Minimum	16026248
5-th percentile	16039042
Q1	16085831
median	16142786
Q3	16204879
95-th percentile	16249707
Maximum	16260639
Range	234391
Interquartile range (IQR)	119048

Descriptive statistics

Standard deviation	67898.56457
Coefficient of variation (CV)	0.004205801943
Kurtosis	-1.209681161
Mean	16144023.3
Median Absolute Deviation (MAD)	59113
Skewness	0.01914461842
Sum	1.777608719 × 10¹⁴
Variance	4610215070
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16097267	8487	0.1%
16052882	8439	0.1%
16254552	7648	0.1%
16213059	7635	0.1%
16256042	7315	0.1%
16215284	7222	0.1%
16082790	6981	0.1%
16110692	6791	0.1%
16103968	6368	0.1%
16116021	6308	0.1%
Other values (9750)	10937746	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16026248	428	< 0.1%
16026249	20	< 0.1%
16026275	1262	< 0.1%
16026281	1643	< 0.1%
16026294	2159	< 0.1%
16026360	500	< 0.1%
16026367	809	< 0.1%
16026406	2493	< 0.1%
16026430	1009	< 0.1%
16026431	44	< 0.1%

Value	Count	Frequency (%)
16260639	956	< 0.1%
16260604	802	< 0.1%
16260593	1025	< 0.1%
16260580	682	< 0.1%
16260520	1724	< 0.1%
16260519	522	< 0.1%
16260434	665	< 0.1%
16260372	1409	< 0.1%
16260346	625	< 0.1%
16260321	2033	< 0.1%

start_time
Categorical

HIGH CARDINALITY

Distinct	9544
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.0 MiB

2022-01-09 23:41:39 UTC	8487
2022-01-04 12:11:23 UTC	8439
2022-01-31 03:29:21 UTC	7648
2022-01-25 22:00:30 UTC	7635
2022-01-31 11:32:15 UTC	7315
Other values (9539)	10971416

Length

Max length	23
Median length	23
Mean length	23
Min length	23

Characters and Unicode

Total characters	253251620
Distinct characters	16
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	228 ?
Unique (%)	< 0.1%

Sample

1st row	2022-01-14 20:00:38 UTC
2nd row	2022-01-21 17:44:31 UTC
3rd row	2022-01-31 11:47:12 UTC
4th row	2022-01-14 20:39:32 UTC
5th row	2022-01-01 17:56:41 UTC

Common Values

Value	Count	Frequency (%)
2022-01-09 23:41:39 UTC	8487	0.1%
2022-01-04 12:11:23 UTC	8439	0.1%
2022-01-31 03:29:21 UTC	7648	0.1%
2022-01-25 22:00:30 UTC	7635	0.1%
2022-01-31 11:32:15 UTC	7315	0.1%
2022-01-26 08:48:29 UTC	7222	0.1%
2022-01-08 12:17:16 UTC	6981	0.1%
2022-01-12 01:37:39 UTC	6791	0.1%
2022-01-30 05:50:11 UTC	6626	0.1%
2022-01-11 01:05:40 UTC	6368	0.1%
Other values (9534)	10937428	99.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
utc	11010940	33.3%
2022-01-29	478042	1.4%
2022-01-08	453272	1.4%
2022-01-16	446787	1.4%
2022-01-30	440144	1.3%
2022-01-23	424881	1.3%
2022-01-09	417363	1.3%
2022-01-15	400498	1.2%
2022-01-03	398243	1.2%
2022-01-02	383163	1.2%
Other values (8385)	18179487	55.0%

Most occurring characters

Value	Count	Frequency (%)
2	48510811	19.2%
0	35071564	13.8%
1	28562054	11.3%
-	22021880	8.7%
	22021880	8.7%
:	22021880	8.7%
3	11020829	4.4%
U	11010940	4.3%
T	11010940	4.3%
C	11010940	4.3%
Other values (6)	30987902	12.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	154153160	60.9%
Uppercase Letter	33032820	13.0%
Dash Punctuation	22021880	8.7%
Space Separator	22021880	8.7%
Other Punctuation	22021880	8.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	48510811	31.5%
0	35071564	22.8%
1	28562054	18.5%
3	11020829	7.1%
4	7217885	4.7%
5	6638927	4.3%
9	4546135	2.9%
8	4415815	2.9%
6	4093927	2.7%
7	4075213	2.6%

Uppercase Letter

Value	Count	Frequency (%)
U	11010940	33.3%
T	11010940	33.3%
C	11010940	33.3%

Dash Punctuation

Value	Count	Frequency (%)
-	22021880	100.0%

Space Separator

Value	Count	Frequency (%)
	22021880	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	22021880	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	220218800	87.0%
Latin	33032820	13.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	48510811	22.0%
0	35071564	15.9%
1	28562054	13.0%
-	22021880	10.0%
	22021880	10.0%
:	22021880	10.0%
3	11020829	5.0%
4	7217885	3.3%
5	6638927	3.0%
9	4546135	2.1%
Other values (3)	12584955	5.7%

Latin

Value	Count	Frequency (%)
U	11010940	33.3%
T	11010940	33.3%
C	11010940	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	253251620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	48510811	19.2%
0	35071564	13.8%
1	28562054	11.3%
-	22021880	8.7%
	22021880	8.7%
:	22021880	8.7%
3	11020829	4.4%
U	11010940	4.3%
T	11010940	4.3%
C	11010940	4.3%
Other values (6)	30987902	12.2%

offset_ms
Real number (ℝ_≥0)

Distinct	63426
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	778233.6821

Minimum	0
Maximum	10604000
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	84.0 MiB

Quantile statistics

Minimum	0
5-th percentile	72400
Q1	301800
median	589700
Q3	1021500
95-th percentile	2134200
Maximum	10604000
Range	10604000
Interquartile range (IQR)	719700

Descriptive statistics

Standard deviation	718418.5647
Coefficient of variation (CV)	0.9231399016
Kurtosis	11.77352656
Mean	778233.6821
Median Absolute Deviation (MAD)	334800
Skewness	2.511837487
Sum	8.569084379 × 10¹²
Variance	5.16125234 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
71600	1151	< 0.1%
72500	1144	< 0.1%
72300	1144	< 0.1%
72400	1143	< 0.1%
86000	1141	< 0.1%
71000	1141	< 0.1%
72100	1133	< 0.1%
87800	1130	< 0.1%
71700	1117	< 0.1%
73100	1115	< 0.1%
Other values (63416)	10999581	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	< 0.1%
1500	1	< 0.1%
1700	2	< 0.1%
1800	3	< 0.1%
1900	6	< 0.1%
2000	113	< 0.1%
2100	12	< 0.1%
2200	16	< 0.1%
2300	18	< 0.1%
2400	13	< 0.1%

Value	Count	Frequency (%)
10604000	1	< 0.1%
10601000	1	< 0.1%
10600500	1	< 0.1%
10600100	1	< 0.1%
10599400	1	< 0.1%
10599300	1	< 0.1%
10598900	1	< 0.1%
10598100	1	< 0.1%
10594000	1	< 0.1%
10591900	1	< 0.1%

player
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.0 MiB

1	5529239
0	5481701

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	11010940
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	5529239	50.2%
0	5481701	49.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
1	5529239	50.2%
0	5481701	49.8%

Most occurring characters

Value	Count	Frequency (%)
1	5529239	50.2%
0	5481701	49.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11010940	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	5529239	50.2%
0	5481701	49.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	11010940	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	5529239	50.2%
0	5481701	49.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11010940	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	5529239	50.2%
0	5481701	49.8%

type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.0 MiB

issue	10640533
factory_issue	370407

Length

Max length	13
Median length	5
Mean length	5.269119258
Min length	5

Characters and Unicode

Total characters	58017956
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	issue
2nd row	issue
3rd row	issue
4th row	issue
5th row	issue

Common Values

Value	Count	Frequency (%)
issue	10640533	96.6%
factory_issue	370407	3.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
issue	10640533	96.6%
factory_issue	370407	3.4%

Most occurring characters

Value	Count	Frequency (%)
s	22021880	38.0%
i	11010940	19.0%
u	11010940	19.0%
e	11010940	19.0%
f	370407	0.6%
a	370407	0.6%
c	370407	0.6%
t	370407	0.6%
o	370407	0.6%
r	370407	0.6%
Other values (2)	740814	1.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	57647549	99.4%
Connector Punctuation	370407	0.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	22021880	38.2%
i	11010940	19.1%
u	11010940	19.1%
e	11010940	19.1%
f	370407	0.6%
a	370407	0.6%
c	370407	0.6%
t	370407	0.6%
o	370407	0.6%
r	370407	0.6%

Connector Punctuation

Value	Count	Frequency (%)
_	370407	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	57647549	99.4%
Common	370407	0.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	22021880	38.2%
i	11010940	19.1%
u	11010940	19.1%
e	11010940	19.1%
f	370407	0.6%
a	370407	0.6%
c	370407	0.6%
t	370407	0.6%
o	370407	0.6%
r	370407	0.6%

Common

Value	Count	Frequency (%)
_	370407	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	58017956	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	22021880	38.0%
i	11010940	19.0%
u	11010940	19.0%
e	11010940	19.0%
f	370407	0.6%
a	370407	0.6%
c	370407	0.6%
t	370407	0.6%
o	370407	0.6%
r	370407	0.6%
Other values (2)	740814	1.3%

units_number
Real number (ℝ_≥0)

ZEROS

Distinct	478
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.403310707

Minimum	0
Maximum	1023
Zeros	287757
Zeros (%)	2.6%
Negative	0
Negative (%)	0.0%
Memory size	84.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	5
95-th percentile	30
Maximum	1023
Range	1023
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	14.50985953
Coefficient of variation (CV)	2.265993358
Kurtosis	112.9688139
Mean	6.403310707
Median Absolute Deviation (MAD)	0
Skewness	7.182731273
Sum	70506470
Variance	210.5360236
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	6156664	55.9%
2	751997	6.8%
3	496325	4.5%
4	375531	3.4%
5	304250	2.8%
0	287757	2.6%
6	249960	2.3%
7	197167	1.8%
8	172636	1.6%
9	151501	1.4%
Other values (468)	1867152	17.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	287757	2.6%
1	6156664	55.9%
2	751997	6.8%
3	496325	4.5%
4	375531	3.4%
5	304250	2.8%
6	249960	2.3%
7	197167	1.8%
8	172636	1.6%
9	151501	1.4%

Value	Count	Frequency (%)
1023	1	< 0.1%
996	1	< 0.1%
775	3	< 0.1%
771	1	< 0.1%
757	1	< 0.1%
750	1	< 0.1%
744	1	< 0.1%
729	2	< 0.1%
726	2	< 0.1%
718	2	< 0.1%

blueprint
Categorical

HIGH CARDINALITY
MISSING

Distinct	439
Distinct (%)	< 0.1%
Missing	7843923
Missing (%)	71.2%
Memory size	84.0 MiB

ueb1103	247084
urb1103	194437
uel0201	102051
xsb1103	99743
url0107	96014
Other values (434)	2427688

Length

Max length	22
Median length	7
Mean length	7.002881576
Min length	7

Characters and Unicode

Total characters	22178245
Distinct characters	33
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	ueb1103
2nd row	zeb9501
3rd row	uab1103
4th row	urb0101
5th row	uab1103

Common Values

Value	Count	Frequency (%)
ueb1103	247084	2.2%
urb1103	194437	1.8%
uel0201	102051	0.9%
xsb1103	99743	0.9%
url0107	96014	0.9%
uel0105	90410	0.8%
ueb0101	89797	0.8%
uab1103	88685	0.8%
ueb1101	74725	0.7%
url0105	68339	0.6%
Other values (429)	2015732	18.3%
(Missing)	7843923	71.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ueb1103	247084	7.8%
urb1103	194437	6.1%
uel0201	102051	3.2%
xsb1103	99743	3.1%
url0107	96014	3.0%
uel0105	90410	2.9%
ueb0101	89797	2.8%
uab1103	88685	2.8%
ueb1101	74725	2.4%
url0105	68339	2.2%
Other values (429)	2015732	63.6%

Most occurring characters

Value	Count	Frequency (%)
0	4786196	21.6%
1	4443340	20.0%
u	2581461	11.6%
b	1917162	8.6%
2	1357505	6.1%
e	1263526	5.7%
3	1161854	5.2%
r	974974	4.4%
l	959152	4.3%
a	676335	3.0%
Other values (23)	2056740	9.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	12664416	57.1%
Lowercase Letter	9512017	42.9%
Connector Punctuation	1812	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	2581461	27.1%
b	1917162	20.2%
e	1263526	13.3%
r	974974	10.2%
l	959152	10.1%
a	676335	7.1%
s	543616	5.7%
x	525337	5.5%
z	30271	0.3%
d	30031	0.3%
Other values (12)	10152	0.1%

Decimal Number

Value	Count	Frequency (%)
0	4786196	37.8%
1	4443340	35.1%
2	1357505	10.7%
3	1161854	9.2%
5	378076	3.0%
4	252384	2.0%
7	109992	0.9%
6	80636	0.6%
9	47301	0.4%
8	47132	0.4%

Connector Punctuation

Value	Count	Frequency (%)
_	1812	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	12666228	57.1%
Latin	9512017	42.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	2581461	27.1%
b	1917162	20.2%
e	1263526	13.3%
r	974974	10.2%
l	959152	10.1%
a	676335	7.1%
s	543616	5.7%
x	525337	5.5%
z	30271	0.3%
d	30031	0.3%
Other values (12)	10152	0.1%

Common

Value	Count	Frequency (%)
0	4786196	37.8%
1	4443340	35.1%
2	1357505	10.7%
3	1161854	9.2%
5	378076	3.0%
4	252384	2.0%
7	109992	0.9%
6	80636	0.6%
9	47301	0.4%
8	47132	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	22178245	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4786196	21.6%
1	4443340	20.0%
u	2581461	11.6%
b	1917162	8.6%
2	1357505	6.1%
e	1263526	5.7%
3	1161854	5.2%
r	974974	4.4%
l	959152	4.3%
a	676335	3.0%
Other values (23)	2056740	9.3%

position_x
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	5142308
Distinct (%)	65.2%
Missing	3127839
Missing (%)	28.4%
Infinite	0
Infinite (%)	0.0%
Mean	243.2068727

Minimum	-0.9994506836
Maximum	1023.636841
Zeros	4
Zeros (%)	< 0.1%
Negative	265
Negative (%)	< 0.1%
Memory size	84.0 MiB

Quantile statistics

Minimum	-0.9994506836
5-th percentile	34.24407196
Q1	109.5
median	206.5
Q3	347.1822815
95-th percentile	524.2194824
Maximum	1023.636841
Range	1024.636292
Interquartile range (IQR)	237.6822815

Descriptive statistics

Standard deviation	173.9242276
Coefficient of variation (CV)	0.7151287528
Kurtosis	1.488285957
Mean	243.2068727
Median Absolute Deviation (MAD)	112.869194
Skewness	1.137607706
Sum	1917224342
Variance	30249.63694
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.5	16968	0.2%
40.5	14023	0.1%
473.5	12737	0.1%
51.5	11269	0.1%
41.5	11155	0.1%
49.5	10609	0.1%
35.5	10355	0.1%
168.5	9948	0.1%
50.5	9663	0.1%
206.5	9551	0.1%
Other values (5142298)	7766823	70.5%
(Missing)	3127839	28.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.9994506836	2	< 0.1%
-0.998916626	1	< 0.1%
-0.9967193604	1	< 0.1%
-0.9954833984	1	< 0.1%
-0.9945831299	1	< 0.1%
-0.9942474365	1	< 0.1%
-0.9926376343	1	< 0.1%
-0.9925613403	1	< 0.1%
-0.991897583	1	< 0.1%
-0.9903335571	1	< 0.1%

Value	Count	Frequency (%)
1023.636841	1	< 0.1%
1023.518677	1	< 0.1%
1023.495728	1	< 0.1%
1023.398315	1	< 0.1%
1023.184204	1	< 0.1%
1023.02478	1	< 0.1%
1022.907349	1	< 0.1%
1022.822754	1	< 0.1%
1022.746582	1	< 0.1%
1022.736816	1	< 0.1%

position_y
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	5007556
Distinct (%)	63.5%
Missing	3127839
Missing (%)	28.4%
Infinite	0
Infinite (%)	0.0%
Mean	243.6739392

Minimum	-0.9995269775
Maximum	1023.869507
Zeros	4
Zeros (%)	< 0.1%
Negative	112
Negative (%)	< 0.1%
Memory size	84.0 MiB

Quantile statistics

Minimum	-0.9995269775
5-th percentile	34.16803741
Q1	107.0003128
median	207.829895
Q3	337.9939575
95-th percentile	544.1104126
Maximum	1023.869507
Range	1024.869034
Interquartile range (IQR)	230.9936447

Descriptive statistics

Standard deviation	177.3032438
Coefficient of variation (CV)	0.7276249745
Kurtosis	1.861659264
Mean	243.6739392
Median Absolute Deviation (MAD)	113.7306061
Skewness	1.246542312
Sum	1920906274
Variance	31436.44027
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51.5	13956	0.1%
205.5	13721	0.1%
47.5	12771	0.1%
48.5	12593	0.1%
226.5	11998	0.1%
40.5	11797	0.1%
195.5	11045	0.1%
180.5	10896	0.1%
38.5	10874	0.1%
464.5	10766	0.1%
Other values (5007546)	7762684	70.5%
(Missing)	3127839	28.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.9995269775	1	< 0.1%
-0.98487854	1	< 0.1%
-0.9776687622	1	< 0.1%
-0.9639511108	1	< 0.1%
-0.9622573853	1	< 0.1%
-0.9257354736	1	< 0.1%
-0.9211120605	1	< 0.1%
-0.9156646729	1	< 0.1%
-0.9129180908	1	< 0.1%
-0.9081954956	1	< 0.1%

Value	Count	Frequency (%)
1023.869507	1	< 0.1%
1023.563232	1	< 0.1%
1023.524658	1	< 0.1%
1023.001343	1	< 0.1%
1022.861023	1	< 0.1%
1022.859375	1	< 0.1%
1022.858398	1	< 0.1%
1022.848389	1	< 0.1%
1022.674316	1	< 0.1%
1022.67395	1	< 0.1%

command_name
Categorical

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.0 MiB

Move	5434086
BuildMobile	1466267
BuildFactory	1243056
Reclaim	708243
Attack	694069
Other values (26)	1465219

Length

Max length	28
Median length	25
Mean length	6.694862655
Min length	4

Characters and Unicode

Total characters	73716731
Distinct characters	37
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Stop
2nd row	Stop
3rd row	FormMove
4th row	Stop
5th row	Stop

Common Values

Value	Count	Frequency (%)
Move	5434086	49.4%
BuildMobile	1466267	13.3%
BuildFactory	1243056	11.3%
Reclaim	708243	6.4%
Attack	694069	6.3%
Guard	458558	4.2%
AggressiveMove	314470	2.9%
Patrol	233654	2.1%
Upgrade	162758	1.5%
Repair	74497	0.7%
Other values (21)	221282	2.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
move	5434086	49.4%
buildmobile	1466267	13.3%
buildfactory	1243056	11.3%
reclaim	708243	6.4%
attack	694069	6.3%
guard	458558	4.2%
aggressivemove	314470	2.9%
patrol	233654	2.1%
upgrade	162758	1.5%
repair	74497	0.7%
Other values (21)	221282	2.0%

Most occurring characters

Value	Count	Frequency (%)
o	8899044	12.1%
e	8891127	12.1%
M	7248407	9.8%
v	6117773	8.3%
i	5407627	7.3%
l	5151305	7.0%
a	3716039	5.0%
d	3376345	4.6%
u	3181654	4.3%
t	3083295	4.2%
Other values (27)	18644115	25.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	59525386	80.7%
Uppercase Letter	14191345	19.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	8899044	14.9%
e	8891127	14.9%
v	6117773	10.3%
i	5407627	9.1%
l	5151305	8.7%
a	3716039	6.2%
d	3376345	5.7%
u	3181654	5.3%
t	3083295	5.2%
c	2741364	4.6%
Other values (11)	8959813	15.1%

Uppercase Letter

Value	Count	Frequency (%)
M	7248407	51.1%
B	2709323	19.1%
F	1279826	9.0%
A	1015995	7.2%
R	784474	5.5%
G	458558	3.2%
P	233654	1.6%
U	231201	1.6%
S	108932	0.8%
T	56579	0.4%
Other values (6)	64396	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	73716731	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	8899044	12.1%
e	8891127	12.1%
M	7248407	9.8%
v	6117773	8.3%
i	5407627	7.3%
l	5151305	7.0%
a	3716039	5.0%
d	3376345	4.6%
u	3181654	4.3%
t	3083295	4.2%
Other values (27)	18644115	25.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	73716731	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	8899044	12.1%
e	8891127	12.1%
M	7248407	9.8%
v	6117773	8.3%
i	5407627	7.3%
l	5151305	7.0%
a	3716039	5.0%
d	3376345	4.6%
u	3181654	4.3%
t	3083295	4.2%
Other values (27)	18644115	25.3%

faf_player_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1641
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	246081.3662

Minimum	144
Maximum	434794
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.0 MiB

Quantile statistics

Minimum	144
5-th percentile	14947
Q1	108922
median	275960
Q3	382548
95-th percentile	431090
Maximum	434794
Range	434650
Interquartile range (IQR)	273626

Descriptive statistics

Standard deviation	146273.7171
Coefficient of variation (CV)	0.5944120003
Kurtosis	-1.378246707
Mean	246081.3662
Median Absolute Deviation (MAD)	125681
Skewness	-0.283357954
Sum	2.709587159 × 10¹²
Variance	2.139600033 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2642	128382	1.2%
33632	117469	1.1%
151257	101112	0.9%
426415	100733	0.9%
105808	92342	0.8%
116558	91373	0.8%
335089	90704	0.8%
19844	89874	0.8%
256949	89088	0.8%
64928	88863	0.8%
Other values (1631)	10021000	91.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
144	3581	< 0.1%
145	12240	0.1%
259	76215	0.7%
434	18216	0.2%
435	45049	0.4%
606	11176	0.1%
648	20497	0.2%
899	6155	0.1%
900	5427	< 0.1%
1065	1163	< 0.1%

Value	Count	Frequency (%)
434794	538	< 0.1%
434789	405	< 0.1%
434782	2798	< 0.1%
434760	1	< 0.1%
434759	832	< 0.1%
434758	496	< 0.1%
434753	1980	< 0.1%
434744	3544	< 0.1%
434736	1048	< 0.1%
434731	336	< 0.1%

login
Categorical

HIGH CARDINALITY

Distinct	1660
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.0 MiB

nemir	128382
silentNoob	117469
Solstice245	101112
fagina_humpalot	100733
lansraad01	92342
Other values (1655)	10470902

Length

Max length	16
Median length	12
Mean length	8.623896143
Min length	2

Characters and Unicode

Total characters	94957203
Distinct characters	64
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	< 0.1%

Sample

1st row	Glassy
2nd row	Morax
3rd row	trandan
4th row	Morax
5th row	Keksyamba

Common Values

Value	Count	Frequency (%)
nemir	128382	1.2%
silentNoob	117469	1.1%
Solstice245	101112	0.9%
fagina_humpalot	100733	0.9%
lansraad01	92342	0.8%
coca	91373	0.8%
Iruma-Kun	90704	0.8%
Electrician	89874	0.8%
b1adam	89088	0.8%
Morax	88863	0.8%
Other values (1650)	10021000	91.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nemir	128382	1.2%
silentnoob	117469	1.1%
solstice245	101112	0.9%
fagina_humpalot	100733	0.9%
lansraad01	92342	0.8%
coca	91373	0.8%
iruma-kun	90704	0.8%
electrician	89874	0.8%
b1adam	89088	0.8%
morax	88863	0.8%
Other values (1648)	10021000	91.0%

Most occurring characters

Value	Count	Frequency (%)
a	8000104	8.4%
e	7054644	7.4%
r	6529821	6.9%
o	6236728	6.6%
i	5274867	5.6%
n	5055565	5.3%
t	3918019	4.1%
l	3602500	3.8%
s	3146205	3.3%
u	2581629	2.7%
Other values (54)	43557121	45.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	71956765	75.8%
Uppercase Letter	15385870	16.2%
Decimal Number	6032350	6.4%
Connector Punctuation	1308272	1.4%
Dash Punctuation	273946	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	8000104	11.1%
e	7054644	9.8%
r	6529821	9.1%
o	6236728	8.7%
i	5274867	7.3%
n	5055565	7.0%
t	3918019	5.4%
l	3602500	5.0%
s	3146205	4.4%
u	2581629	3.6%
Other values (16)	20556683	28.6%

Uppercase Letter

Value	Count	Frequency (%)
S	1301155	8.5%
N	1097532	7.1%
A	996613	6.5%
T	959550	6.2%
R	878787	5.7%
L	785871	5.1%
K	767418	5.0%
P	758253	4.9%
B	737636	4.8%
C	723558	4.7%
Other values (16)	6379497	41.5%

Decimal Number

Value	Count	Frequency (%)
0	1219435	20.2%
1	1011279	16.8%
2	959660	15.9%
3	683473	11.3%
4	436336	7.2%
6	415674	6.9%
5	407874	6.8%
7	331704	5.5%
9	297898	4.9%
8	269017	4.5%

Connector Punctuation

Value	Count	Frequency (%)
_	1308272	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	273946	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	87342635	92.0%
Common	7614568	8.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	8000104	9.2%
e	7054644	8.1%
r	6529821	7.5%
o	6236728	7.1%
i	5274867	6.0%
n	5055565	5.8%
t	3918019	4.5%
l	3602500	4.1%
s	3146205	3.6%
u	2581629	3.0%
Other values (42)	35942553	41.2%

Common

Value	Count	Frequency (%)
_	1308272	17.2%
0	1219435	16.0%
1	1011279	13.3%
2	959660	12.6%
3	683473	9.0%
4	436336	5.7%
6	415674	5.5%
5	407874	5.4%
7	331704	4.4%
9	297898	3.9%
Other values (2)	542963	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	94957203	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	8000104	8.4%
e	7054644	7.4%
r	6529821	6.9%
o	6236728	6.6%
i	5274867	5.6%
n	5055565	5.3%
t	3918019	4.1%
l	3602500	3.8%
s	3146205	3.3%
u	2581629	2.7%
Other values (54)	43557121	45.9%

rating
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	2338
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	743.9465493

Minimum	-534
Maximum	2263
Zeros	167306
Zeros (%)	1.5%
Negative	472068
Negative (%)	4.3%
Memory size	84.0 MiB

Quantile statistics

Minimum	-534
5-th percentile	0
Q1	399
median	675
Q3	1064
95-th percentile	1728
Maximum	2263
Range	2797
Interquartile range (IQR)	665

Descriptive statistics

Standard deviation	503.7306672
Coefficient of variation (CV)	0.6771059932
Kurtosis	-0.1242216603
Mean	743.9465493
Median Absolute Deviation (MAD)	313
Skewness	0.4822597011
Sum	8191550818
Variance	253744.585
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	167306	1.5%
1466	50548	0.5%
733	22222	0.2%
650	21715	0.2%
672	18879	0.2%
500	17966	0.2%
496	17781	0.2%
745	17778	0.2%
477	17412	0.2%
604	17189	0.2%
Other values (2328)	10642144	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-534	285	< 0.1%
-529	1392	< 0.1%
-528	173	< 0.1%
-526	683	< 0.1%
-513	611	< 0.1%
-510	105	< 0.1%
-507	513	< 0.1%
-503	280	< 0.1%
-499	317	< 0.1%
-497	407	< 0.1%

Value	Count	Frequency (%)
2263	1427	< 0.1%
2247	947	< 0.1%
2234	2916	< 0.1%
2215	869	< 0.1%
2213	1046	< 0.1%
2206	1630	< 0.1%
2203	751	< 0.1%
2202	2745	< 0.1%
2201	1416	< 0.1%
2197	1130	< 0.1%

faction
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.0 MiB

UEF	4288313
Cybran	3289699
Seraphim	1818564
Aeon	1614364

Length

Max length	8
Median length	6
Mean length	4.86871248
Min length	3

Characters and Unicode

Total characters	53609101
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Seraphim
2nd row	UEF
3rd row	Seraphim
4th row	Aeon
5th row	UEF

Common Values

Value	Count	Frequency (%)
UEF	4288313	38.9%
Cybran	3289699	29.9%
Seraphim	1818564	16.5%
Aeon	1614364	14.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
uef	4288313	38.9%
cybran	3289699	29.9%
seraphim	1818564	16.5%
aeon	1614364	14.7%

Most occurring characters

Value	Count	Frequency (%)
r	5108263	9.5%
a	5108263	9.5%
n	4904063	9.1%
E	4288313	8.0%
U	4288313	8.0%
F	4288313	8.0%
e	3432928	6.4%
b	3289699	6.1%
y	3289699	6.1%
C	3289699	6.1%
Other values (7)	12321548	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	34021535	63.5%
Uppercase Letter	19587566	36.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	5108263	15.0%
a	5108263	15.0%
n	4904063	14.4%
e	3432928	10.1%
b	3289699	9.7%
y	3289699	9.7%
p	1818564	5.3%
h	1818564	5.3%
i	1818564	5.3%
m	1818564	5.3%

Uppercase Letter

Value	Count	Frequency (%)
E	4288313	21.9%
U	4288313	21.9%
F	4288313	21.9%
C	3289699	16.8%
S	1818564	9.3%
A	1614364	8.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	53609101	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	5108263	9.5%
a	5108263	9.5%
n	4904063	9.1%
E	4288313	8.0%
U	4288313	8.0%
F	4288313	8.0%
e	3432928	6.4%
b	3289699	6.1%
y	3289699	6.1%
C	3289699	6.1%
Other values (7)	12321548	23.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	53609101	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	5108263	9.5%
a	5108263	9.5%
n	4904063	9.1%
E	4288313	8.0%
U	4288313	8.0%
F	4288313	8.0%
e	3432928	6.4%
b	3289699	6.1%
y	3289699	6.1%
C	3289699	6.1%
Other values (7)	12321548	23.0%

map_name
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.0 MiB

Loki - FAF version	1630973
Twin Rivers	1589679
Eye of the Storm - FAF version	1502786
Desert Arena - FAF version	1214030
Ambush Pass	1156201
Other values (23)	3917271

Length

Max length	32
Median length	30
Mean length	19.29911869
Min length	6

Characters and Unicode

Total characters	212501438
Distinct characters	50
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Regor VI Highlands
2nd row	White Fire - FAF version
3rd row	The Bermuda Locket - FAF version
4th row	White Fire - FAF version
5th row	Crossfire Canal - FAF version

Common Values

Value	Count	Frequency (%)
Loki - FAF version	1630973	14.8%
Twin Rivers	1589679	14.4%
Eye of the Storm - FAF version	1502786	13.6%
Desert Arena - FAF version	1214030	11.0%
Ambush Pass	1156201	10.5%
Sentry Point	953144	8.7%
Seraphim Glaciers - FAF version	824821	7.5%
Syrtis Major - FAF version	754944	6.9%
Broken_Vows	615600	5.6%
Roanoke Abyss	296179	2.7%
Other values (18)	472583	4.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	6111653	14.8%
version	6088467	14.8%
faf	6088467	14.8%
loki	1630973	4.0%
twin	1589679	3.9%
rivers	1589679	3.9%
the	1568274	3.8%
of	1509502	3.7%
eye	1502786	3.6%
storm	1502786	3.6%
Other values (47)	12023288	29.2%

Most occurring characters

Value	Count	Frequency (%)
	30194614	14.2%
e	18521057	8.7%
r	16678951	7.8%
s	15473354	7.3%
i	14597678	6.9%
o	14554590	6.8%
F	12300544	5.8%
n	12037789	5.7%
A	8779831	4.1%
v	7734628	3.6%
Other values (40)	61628402	29.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	136491634	64.2%
Uppercase Letter	38902722	18.3%
Space Separator	30194614	14.2%
Dash Punctuation	6120899	2.9%
Connector Punctuation	663722	0.3%
Other Punctuation	65513	< 0.1%
Decimal Number	62334	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	18521057	13.6%
r	16678951	12.2%
s	15473354	11.3%
i	14597678	10.7%
o	14554590	10.7%
n	12037789	8.8%
v	7734628	5.7%
t	7119571	5.2%
a	5543133	4.1%
h	3733237	2.7%
Other values (15)	20497646	15.0%

Uppercase Letter

Value	Count	Frequency (%)
F	12300544	31.6%
A	8779831	22.6%
S	4042686	10.4%
P	2167677	5.6%
R	2039765	5.2%
L	1696461	4.4%
T	1680103	4.3%
E	1502786	3.9%
D	1217706	3.1%
G	849757	2.2%
Other values (8)	2625406	6.7%

Decimal Number

Value	Count	Frequency (%)
4	29902	48.0%
8	23186	37.2%
3	9246	14.8%

Space Separator

Value	Count	Frequency (%)
	30194614	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6120899	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	663722	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	65513	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	175394356	82.5%
Common	37107082	17.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	18521057	10.6%
r	16678951	9.5%
s	15473354	8.8%
i	14597678	8.3%
o	14554590	8.3%
F	12300544	7.0%
n	12037789	6.9%
A	8779831	5.0%
v	7734628	4.4%
t	7119571	4.1%
Other values (33)	47596363	27.1%

Common

Value	Count	Frequency (%)
	30194614	81.4%
-	6120899	16.5%
_	663722	1.8%
'	65513	0.2%
4	29902	0.1%
8	23186	0.1%
3	9246	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	212501438	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	30194614	14.2%
e	18521057	8.7%
r	16678951	7.8%
s	15473354	7.3%
i	14597678	6.9%
o	14554590	6.8%
F	12300544	5.8%
n	12037789	5.7%
A	8779831	4.1%
v	7734628	3.6%
Other values (40)	61628402	29.0%

map_thumbnail
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.0 MiB

https://content.faforever.com/maps/previews/large/loki_-_faf_version.v0003.png	1630973
https://content.faforever.com/maps/previews/large/twin rivers.v0001.png	1589679
https://content.faforever.com/maps/previews/large/eye_of_the_storm_-_faf_version.v0002.png	1502786
https://content.faforever.com/maps/previews/large/desert_arena_-_faf_version.v0002.png	1214030
https://content.faforever.com/maps/previews/large/scmp_038.png	1156201
Other values (23)	3917271

Length

Max length	92
Median length	90
Mean length	77.08422206
Min length	62

Characters and Unicode

Total characters	848769744
Distinct characters	40
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	https://content.faforever.com/maps/previews/large/regor_vi_highlands.v0006.png
2nd row	https://content.faforever.com/maps/previews/large/white_fire_-_faf_version.v0002.png
3rd row	https://content.faforever.com/maps/previews/large/the_bermuda_locket_-_faf_version.v0001.png
4th row	https://content.faforever.com/maps/previews/large/white_fire_-_faf_version.v0002.png
5th row	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png

Common Values

Value	Count	Frequency (%)
https://content.faforever.com/maps/previews/large/loki_-_faf_version.v0003.png	1630973	14.8%
https://content.faforever.com/maps/previews/large/twin rivers.v0001.png	1589679	14.4%
https://content.faforever.com/maps/previews/large/eye_of_the_storm_-_faf_version.v0002.png	1502786	13.6%
https://content.faforever.com/maps/previews/large/desert_arena_-_faf_version.v0002.png	1214030	11.0%
https://content.faforever.com/maps/previews/large/scmp_038.png	1156201	10.5%
https://content.faforever.com/maps/previews/large/scmp_018.png	953144	8.7%
https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	824821	7.5%
https://content.faforever.com/maps/previews/large/syrtis_major_-_faf_version.v0002.png	754944	6.9%
https://content.faforever.com/maps/previews/large/broken_vows.v0008.png	615600	5.6%
https://content.faforever.com/maps/previews/large/scmp_020.png	296179	2.7%
Other values (18)	472583	4.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://content.faforever.com/maps/previews/large/loki_-_faf_version.v0003.png	1630973	12.8%
rivers.v0001.png	1589679	12.4%
https://content.faforever.com/maps/previews/large/twin	1589679	12.4%
https://content.faforever.com/maps/previews/large/eye_of_the_storm_-_faf_version.v0002.png	1502786	11.8%
https://content.faforever.com/maps/previews/large/desert_arena_-_faf_version.v0002.png	1214030	9.5%
https://content.faforever.com/maps/previews/large/scmp_038.png	1156201	9.1%
https://content.faforever.com/maps/previews/large/scmp_018.png	953144	7.5%
https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	824821	6.5%
https://content.faforever.com/maps/previews/large/syrtis_major_-_faf_version.v0002.png	754944	5.9%
https://content.faforever.com/maps/previews/large/broken_vows.v0008.png	615600	4.8%
Other values (28)	939647	7.4%

Most occurring characters

Value	Count	Frequency (%)
e	84699558	10.0%
/	66065640	7.8%
r	61457414	7.2%
t	50902417	6.0%
s	49942173	5.9%
p	47366008	5.6%
o	46009795	5.4%
a	44372143	5.2%
n	42739041	5.0%
.	41500364	4.9%
Other values (30)	313715191	37.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	651779566	76.8%
Other Punctuation	118576944	14.0%
Decimal Number	41421159	4.9%
Connector Punctuation	29119858	3.4%
Dash Punctuation	6111653	0.7%
Space Separator	1760564	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	84699558	13.0%
r	61457414	9.4%
t	50902417	7.8%
s	49942173	7.7%
p	47366008	7.3%
o	46009795	7.1%
a	44372143	6.8%
n	42739041	6.6%
v	38964637	6.0%
f	35849266	5.5%
Other values (14)	149477114	22.9%

Decimal Number

Value	Count	Frequency (%)
0	28235568	68.2%
2	3872631	9.3%
1	3540223	8.5%
3	2822431	6.8%
8	2748131	6.6%
6	85058	0.2%
7	57320	0.1%
4	29902	0.1%
9	26580	0.1%
5	3315	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	66065640	55.7%
.	41500364	35.0%
:	11010940	9.3%

Connector Punctuation

Value	Count	Frequency (%)
_	29119858	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6111653	100.0%

Space Separator

Value	Count	Frequency (%)
	1760564	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	651779566	76.8%
Common	196990178	23.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	84699558	13.0%
r	61457414	9.4%
t	50902417	7.8%
s	49942173	7.7%
p	47366008	7.3%
o	46009795	7.1%
a	44372143	6.8%
n	42739041	6.6%
v	38964637	6.0%
f	35849266	5.5%
Other values (14)	149477114	22.9%

Common

Value	Count	Frequency (%)
/	66065640	33.5%
.	41500364	21.1%
_	29119858	14.8%
0	28235568	14.3%
:	11010940	5.6%
-	6111653	3.1%
2	3872631	2.0%
1	3540223	1.8%
3	2822431	1.4%
8	2748131	1.4%
Other values (6)	1962739	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	848769744	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	84699558	10.0%
/	66065640	7.8%
r	61457414	7.2%
t	50902417	6.0%
s	49942173	5.9%
p	47366008	5.6%
o	46009795	5.4%
a	44372143	5.2%
n	42739041	5.0%
.	41500364	4.9%
Other values (30)	313715191	37.0%

map_width
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.0 MiB

512	6433229
256	3350573
1024	1227138

Length

Max length	4
Median length	3
Mean length	3.111447161
Min length	3

Characters and Unicode

Total characters	34259958
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	512
2nd row	512
3rd row	1024
4th row	512
5th row	1024

Common Values

Value	Count	Frequency (%)
512	6433229	58.4%
256	3350573	30.4%
1024	1227138	11.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
512	6433229	58.4%
256	3350573	30.4%
1024	1227138	11.1%

Most occurring characters

Value	Count	Frequency (%)
2	11010940	32.1%
5	9783802	28.6%
1	7660367	22.4%
6	3350573	9.8%
0	1227138	3.6%
4	1227138	3.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	34259958	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	11010940	32.1%
5	9783802	28.6%
1	7660367	22.4%
6	3350573	9.8%
0	1227138	3.6%
4	1227138	3.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	34259958	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	11010940	32.1%
5	9783802	28.6%
1	7660367	22.4%
6	3350573	9.8%
0	1227138	3.6%
4	1227138	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	34259958	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	11010940	32.1%
5	9783802	28.6%
1	7660367	22.4%
6	3350573	9.8%
0	1227138	3.6%
4	1227138	3.6%

map_height
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	84.0 MiB

512	6433229
256	3350573
1024	1227138

Length

Max length	4
Median length	3
Mean length	3.111447161
Min length	3

Characters and Unicode

Total characters	34259958
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	512
2nd row	512
3rd row	1024
4th row	512
5th row	1024

Common Values

Value	Count	Frequency (%)
512	6433229	58.4%
256	3350573	30.4%
1024	1227138	11.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
512	6433229	58.4%
256	3350573	30.4%
1024	1227138	11.1%

Most occurring characters

Value	Count	Frequency (%)
2	11010940	32.1%
5	9783802	28.6%
1	7660367	22.4%
6	3350573	9.8%
0	1227138	3.6%
4	1227138	3.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	34259958	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	11010940	32.1%
5	9783802	28.6%
1	7660367	22.4%
6	3350573	9.8%
0	1227138	3.6%
4	1227138	3.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	34259958	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	11010940	32.1%
5	9783802	28.6%
1	7660367	22.4%
6	3350573	9.8%
0	1227138	3.6%
4	1227138	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	34259958	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	11010940	32.1%
5	9783802	28.6%
1	7660367	22.4%
6	3350573	9.8%
0	1227138	3.6%
4	1227138	3.6%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	start_time	offset_ms	player	type	units_number	blueprint	position_x	position_y	command_name	faf_player_id	login	rating	faction	map_name	map_thumbnail	map_width	map_height
0	16128316	2022-01-14 20:00:38 UTC	1047300	1	issue	2	NaN	NaN	NaN	Stop	92766	Glassy	1577	Seraphim	Regor VI Highlands	https://content.faforever.com/maps/previews/large/regor_vi_highlands.v0006.png	512	512
1	16178891	2022-01-21 17:44:31 UTC	927000	1	issue	1	NaN	NaN	NaN	Stop	64928	Morax	1750	UEF	White Fire - FAF version	https://content.faforever.com/maps/previews/large/white_fire_-_faf_version.v0002.png	512	512
2	16256113	2022-01-31 11:47:12 UTC	1467100	1	issue	98	NaN	671.567932	271.309540	FormMove	108922	trandan	1772	Seraphim	The Bermuda Locket - FAF version	https://content.faforever.com/maps/previews/large/the_bermuda_locket_-_faf_version.v0001.png	1024	1024
3	16128700	2022-01-14 20:39:32 UTC	406700	1	issue	1	NaN	NaN	NaN	Stop	64928	Morax	1759	Aeon	White Fire - FAF version	https://content.faforever.com/maps/previews/large/white_fire_-_faf_version.v0002.png	512	512
4	16031045	2022-01-01 17:56:41 UTC	659300	1	issue	1	NaN	NaN	NaN	Stop	366264	Keksyamba	636	UEF	Crossfire Canal - FAF version	https://content.faforever.com/maps/previews/large/crossfire_canal_-_faf_version.v0002.png	1024	1024
5	16109685	2022-01-11 21:49:28 UTC	193300	1	issue	3	NaN	274.293945	372.844299	FormMove	63950	EcoNoob	1965	Cybran	The Bermuda Locket - FAF version	https://content.faforever.com/maps/previews/large/the_bermuda_locket_-_faf_version.v0001.png	1024	1024
6	16169188	2022-01-20 04:17:32 UTC	1188100	1	issue	1	NaN	NaN	NaN	Capture	270014	ikigami	1939	Seraphim	Regor VI Highlands	https://content.faforever.com/maps/previews/large/regor_vi_highlands.v0006.png	512	512
7	16030323	2022-01-01 16:26:41 UTC	756900	1	issue	1	NaN	NaN	NaN	Script	174608	MAPTOC	1466	Cybran	Vulcan's Reach	https://content.faforever.com/maps/previews/large/vulcans reach.v0003.png	512	512
8	16042149	2022-01-02 22:38:24 UTC	1574000	1	issue	1	NaN	NaN	NaN	OverCharge	33632	silentNoob	1745	Cybran	Regor VI Highlands	https://content.faforever.com/maps/previews/large/regor_vi_highlands.v0006.png	512	512
9	16027406	2022-01-01 05:11:40 UTC	1205500	0	issue	1	NaN	NaN	NaN	OverCharge	356435	Flanking_Octopus	528	Seraphim	TAG_Craftious Maximus	https://content.faforever.com/maps/previews/large/tag_craftious maximus.v0001.png	512	512

Last rows

	id	start_time	offset_ms	player	type	units_number	blueprint	position_x	position_y	command_name	faf_player_id	login	rating	faction	map_name	map_thumbnail	map_width	map_height
11010930	16035516	2022-01-02 04:44:56 UTC	1021800	1	issue	1	NaN	193.058014	754.344666	AggressiveMove	362625	Vaangard	576	UEF	Seraphim Glaciers - FAF version	https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	1024	1024
11010931	16247311	2022-01-30 11:35:19 UTC	2587300	1	issue	57	NaN	233.420425	685.052124	AggressiveMove	432736	Raderblob	527	UEF	Seraphim Glaciers - FAF version	https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	1024	1024
11010932	16198170	2022-01-23 19:33:34 UTC	738800	0	issue	8	NaN	205.886200	286.587585	AggressiveMove	219084	Conorach	1386	Aeon	Seraphim Glaciers - FAF version	https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	1024	1024
11010933	16253962	2022-01-31 01:08:07 UTC	631400	1	issue	1	NaN	673.692322	207.052368	AggressiveMove	64928	Morax	1753	Aeon	Seraphim Glaciers - FAF version	https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	1024	1024
11010934	16158675	2022-01-18 16:05:33 UTC	806000	0	issue	1	NaN	402.206024	235.428619	AggressiveMove	285415	Hemfast	838	Seraphim	Seraphim Glaciers - FAF version	https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	1024	1024
11010935	16247311	2022-01-30 11:35:19 UTC	1380100	1	issue	49	NaN	633.414185	624.077637	AggressiveMove	432736	Raderblob	527	UEF	Seraphim Glaciers - FAF version	https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	1024	1024
11010936	16061853	2022-01-05 16:50:13 UTC	1608800	1	issue	1	NaN	815.276306	622.230347	AggressiveMove	37910	Bjorn	1268	UEF	Seraphim Glaciers - FAF version	https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	1024	1024
11010937	16087136	2022-01-08 20:41:18 UTC	738400	1	issue	17	NaN	241.172546	766.024658	AggressiveMove	376123	naSimka	1246	Cybran	Seraphim Glaciers - FAF version	https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	1024	1024
11010938	16076391	2022-01-07 17:05:11 UTC	753300	0	issue	5	NaN	425.567688	155.549957	AggressiveMove	25711	Swkoll	2149	UEF	Seraphim Glaciers - FAF version	https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	1024	1024
11010939	16249576	2022-01-30 16:23:12 UTC	159300	1	factory_issue	1	NaN	723.345886	831.108093	AggressiveMove	297885	AHTOHOB	1317	Seraphim	Seraphim Glaciers - FAF version	https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	1024	1024

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category